/*
* Sun Public License Notice
*
* The contents of this file are subject to the Sun Public License
* Version 1.0 (the "License"). You may not use this file except in
* compliance with the License. A copy of the License is available at
* http://www.sun.com/
*
* The Original Code is NetBeans. The Initial Developer of the Original
* Code is Sun Microsystems, Inc. Portions Copyright 1997-2001 Sun
* Microsystems, Inc. All Rights Reserved.
*/
package org.netbeans.modules.db.explorer.infos;
import java.sql.*;
import java.util.*;
import org.netbeans.lib.ddl.*;
import org.netbeans.lib.ddl.adaptors.*;
import org.netbeans.lib.ddl.impl.*;
import org.netbeans.modules.db.DatabaseException;
import org.netbeans.modules.db.explorer.DatabaseNodeChildren;
import org.netbeans.modules.db.explorer.infos.*;
import org.netbeans.modules.db.explorer.nodes.*;
import org.netbeans.modules.db.explorer.actions.DatabaseAction;
import org.openide.nodes.Node;
public class TableListNodeInfo extends DatabaseNodeInfo
implements TableOwnerOperations
{
static final long serialVersionUID =-6156362126513404875L;
protected void initChildren(Vector children)
throws DatabaseException
{
try {
DatabaseMetaData dmd = getSpecification().getMetaData();
String catalog = (String) get(DatabaseNode.CATALOG);
String[] types = new String[] {"TABLE"};
DriverSpecification drvSpec = getDriverSpecification();
drvSpec.getTables(catalog, dmd, null, types);
if (drvSpec.rs != null) {
while (drvSpec.rs.next()) {
DatabaseNodeInfo info = DatabaseNodeInfo.createNodeInfo(this, DatabaseNode.TABLE, drvSpec.rs);
if (info != null) {
info.put(DatabaseNode.TABLE, info.getName());
children.add(info);
} else throw new Exception("unable to create node information for table");
}
drvSpec.rs.close();
}
} catch (Exception e) {
throw new DatabaseException(e.getMessage());
}
}
/** Adds driver specified in drv into list.
* Creates new node info and adds node into node children.
*/
public void addTable(String tname)
throws DatabaseException
{
try {
DatabaseMetaData dmd = getSpecification().getMetaData();
String catalog = (String) get(DatabaseNode.CATALOG);
String[] types = new String[] {"TABLE","BASE"};
DriverSpecification drvSpec = getDriverSpecification();
drvSpec.getTables(catalog, dmd, tname, types);
if (drvSpec.rs != null) {
drvSpec.rs.next();
DatabaseNodeInfo info = DatabaseNodeInfo.createNodeInfo(this, DatabaseNode.TABLE, drvSpec.rs);
drvSpec.rs.close();
if (info != null)
info.put(DatabaseNode.TABLE, info.getName());
else
throw new Exception("unable to create node information for table");
DatabaseNodeChildren chld = (DatabaseNodeChildren)getNode().getChildren();
chld.createSubnode(info, true);
}
} catch (Exception e) {
throw new DatabaseException(e.getMessage());
}
}
public void refreshChildren() throws DatabaseException
{
Vector charr = new Vector();
DatabaseNodeChildren chil = (DatabaseNodeChildren)getNode().getChildren();
put(DatabaseNodeInfo.CHILDREN, charr);
chil.remove(chil.getNodes());
initChildren(charr);
Enumeration en = charr.elements();
while(en.hasMoreElements()) {
DatabaseNode subnode = chil.createNode((DatabaseNodeInfo)en.nextElement());
chil.add(new Node[] {subnode});
}
}
/** Returns tablenodeinfo specified by info
* Compares code and name only.
*/
public TableNodeInfo getChildrenTableInfo(TableNodeInfo info)
{
String scode = info.getCode();
String sname = info.getName();
try {
Enumeration enu = getChildren().elements();
while (enu.hasMoreElements()) {
TableNodeInfo elem = (TableNodeInfo)enu.nextElement();
if (elem.getCode().equals(scode) && elem.getName().equals(sname)) {
return elem;
}
}
} catch (Exception e) {}
return null;
}
/*
public void dropIndex(DatabaseNodeInfo tinfo)
throws DatabaseException
{
DatabaseNode node = (DatabaseNode)tinfo.getNode();
DatabaseNodeChildren chld = (DatabaseNodeChildren)getNode().getChildren();
try {
String tname = tinfo.getName();
Specification spec = (Specification)getSpecification();
AbstractCommand cmd = spec.createCommandDropIndex(tname);
cmd.execute();
getNode().getChildren().remove(new Node[]{node});
} catch (Exception e) {
throw new DatabaseException(e.getMessage());
}
}
*/
}
/*
* <<Log>>
* 15 Gandalf 1.14 1/25/00 Radko Najman new driver adaptor
* version
* 14 Gandalf 1.13 12/22/99 Radko Najman Case Identifiers removed
* 13 Gandalf 1.12 12/15/99 Radko Najman driver adaptor
* 12 Gandalf 1.11 11/27/99 Patrik Knakal
* 11 Gandalf 1.10 11/15/99 Radko Najman MS ACCESS
* 10 Gandalf 1.9 10/23/99 Ian Formanek NO SEMANTIC CHANGE - Sun
* Microsystems Copyright in File Comment
* 9 Gandalf 1.8 10/8/99 Radko Najman getUser() method
* replaced by dmd.getUserName()
* 8 Gandalf 1.7 9/13/99 Slavek Psenicka
* 7 Gandalf 1.6 9/13/99 Slavek Psenicka
* 6 Gandalf 1.5 9/8/99 Slavek Psenicka adaptor changes
* 5 Gandalf 1.4 8/19/99 Slavek Psenicka English
* 4 Gandalf 1.3 6/9/99 Ian Formanek ---- Package Change To
* org.openide ----
* 3 Gandalf 1.2 5/21/99 Slavek Psenicka new version
* 2 Gandalf 1.1 5/14/99 Slavek Psenicka new version
* 1 Gandalf 1.0 4/23/99 Slavek Psenicka
* $
*/